Insert Several Rows

Move your mouse cursor to the left over the row number

Drag your mouse cursor from row number to row number

    Excel highlights rows 3 through 5.

Click Insert, Rows on the menu bar

    Since you highlighted three rows, Excel inserts two rows starting at row 3 and moves the remainder of your spreadsheet down.

Now you try.